Account Summary History (GL10111)

azurecurve Products Microsoft Dynamics GP (0)FinancialAccount Summary History (GL10111)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/GL10111

Product: Microsoft Dynamics GP (0)
Series: Financial

Display Name: Account Summary History
Physical Name: GL10111
Technical Name: GL_Account_SUM_HIST

Group Display Name: Account Summary History
Group Technical Name: Account Summary History

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	ACTINDX	Account Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['Account Summary History'].ACTINDX AS 'Account Summary History-Account Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM GL10111 AS ['Account Summary History'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['Account Summary History'].ACTINDX = ['Account Index Master'].ACTINDX
2	YEAR1	Year	Integer	Year	4
3	PERIODID	Period ID	Integer	INT3	3
4	Ledger_ID	Ledger ID	Integer	INT2	2
5	ACTNUMBR_1	Account Number:Account_Segment_Pool1	String	Account_Segment_Pool1	6
6	ACTNUMBR	Account Number	Account_Number	Composite	80
7	ACTNUMBR_2	Account Number:Account_Segment_Pool2	String	Account_Segment_Pool2	6
8	ACTNUMBR_3	Account Number:Account_Segment_Pool3	String	Account_Segment_Pool3	6
9	ACTNUMBR_4	Account Number:Account_Segment_Pool4	String	Account_Segment_Pool4	6
10	ACTNUMBR_5	Account Number:Account_Segment_Pool5	String	Account_Segment_Pool5	6
11	ACTNUMBR_6	Account Number:Account_Segment_Pool6	String	Account_Segment_Pool6	6
12	ACTNUMBR_7	Account Number:Account_Segment_Pool7	String	Account_Segment_Pool7	6
13	ACTNUMBR_8	Account Number:Account_Segment_Pool8	String	Account_Segment_Pool8	6
14	ACTNUMBR_9	Account Number:Account_Segment_Pool9	String	Account_Segment_Pool9	6
15	ACTNUMBR_10	Account Number:Account_Segment_Pool10	String	Account_Segment_Pool10	6
16	ACCATNUM	Account Category Number	Integer	INT2_U0	2
	Key to the Account Category Master (GL00102). Click to show/hide SELECT ['Account Summary History'].ACCATNUM AS 'Account Summary History-Account Category Number' ,['Account Category Master'].ACCATNUM AS 'Account Category Master-Account Category Number' FROM GL10111 AS ['Account Summary History'] INNER JOIN GL00102 AS ['Account Category Master'] ON ['Account Summary History'].ACCATNUM = ['Account Category Master'].ACCATNUM
17	PERDBLNC	Period Balance	Currency	DLR17_$S2	17
18	DEBITAMT	Debit Amount	Currency	DLR19_$S2	19
19	CRDTAMNT	Credit Amount	Currency	DLR19_$S2	19

azurecurve Products Microsoft Dynamics GP (0)FinancialAccount Summary History (GL10111)

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply